Overview

Dataset statistics

Number of variables48
Number of observations2080
Missing cells13548
Missing cells (%)13.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory780.1 KiB
Average record size in memory384.1 B

Variable types

CAT36
NUM11
UNSUPPORTED1

Reproduction

Analysis started2020-06-10 20:13:32.771600
Analysis finished2020-06-10 20:13:54.678962
Duration21.91 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Average Weekly Wage has a high cardinality: 464 distinct values High cardinality
Claimant Atty Firm Name has a high cardinality: 195 distinct values High cardinality
Claimant Hire Date has a high cardinality: 1434 distinct values High cardinality
Detail Cause has a high cardinality: 56 distinct values High cardinality
Dt Reported to Carrier/TPA has a high cardinality: 1547 distinct values High cardinality
Dt Reported to Employer has a high cardinality: 1609 distinct values High cardinality
Date of Injury/Illness has a high cardinality: 1640 distinct values High cardinality
How Injury Occurred has a high cardinality: 2077 distinct values High cardinality
Injury/Illness City has a high cardinality: 392 distinct values High cardinality
Injury/Illness Postal has a high cardinality: 550 distinct values High cardinality
Detail Cause Code is highly correlated with Cause CodeHigh correlation
Cause Code is highly correlated with Detail Cause CodeHigh correlation
Claimant Gender Code is highly correlated with Claimant GenderHigh correlation
Claimant Gender is highly correlated with Claimant Gender CodeHigh correlation
Claimant Marital Status Code is highly correlated with Claimant Marital StatusHigh correlation
Claimant Marital Status is highly correlated with Claimant Marital Status CodeHigh correlation
Claimant State Code is highly correlated with Claimant StateHigh correlation
Claimant State is highly correlated with Claimant State CodeHigh correlation
Detail Cause is highly correlated with CauseHigh correlation
Cause is highly correlated with Detail CauseHigh correlation
Domestic vs. Foreign? Code is highly correlated with Domestic vs. Foreign?High correlation
Domestic vs. Foreign? is highly correlated with Domestic vs. Foreign? CodeHigh correlation
Employment Status Code is highly correlated with Employment StatusHigh correlation
Employment Status is highly correlated with Employment Status CodeHigh correlation
Injury/Illness State Code is highly correlated with Injury/Illness StateHigh correlation
Injury/Illness State is highly correlated with Injury/Illness State CodeHigh correlation
Jurisdiction Code is highly correlated with JurisdictionHigh correlation
Jurisdiction is highly correlated with Jurisdiction CodeHigh correlation
Lost Time or Medical Only? Code is highly correlated with Lost Time or Medical Only?High correlation
Lost Time or Medical Only? is highly correlated with Lost Time or Medical Only? CodeHigh correlation
OSHA Injury Type is highly correlated with Nature of Injury/IllnessHigh correlation
Nature of Injury/Illness is highly correlated with OSHA Injury Type and 2 other fieldsHigh correlation
Type of Loss is highly correlated with Nature of Injury/Illness and 1 other fieldsHigh correlation
Type of Loss Code is highly correlated with Nature of Injury/Illness and 1 other fieldsHigh correlation
Dependent has 2080 (100.0%) missing values Missing
Average Weekly Wage has 1304 (62.7%) missing values Missing
Claimant Age has 308 (14.8%) missing values Missing
Claimant Atty Firm Name has 1695 (81.5%) missing values Missing
Claimant Hire Date has 109 (5.2%) missing values Missing
Claimant Marital Status has 1742 (83.8%) missing values Missing
Claimant Marital Status Code has 1742 (83.8%) missing values Missing
Department Code has 1095 (52.6%) missing values Missing
Injury/Illness Postal has 513 (24.7%) missing values Missing
Number of Dependents has 2016 (96.9%) missing values Missing
Severity Index Code has 41 (2.0%) missing values Missing
Severity Index Code Code has 41 (2.0%) missing values Missing
Reforms_dummy has 837 (40.2%) missing values Missing
Claimant Hire Date is uniformly distributed Uniform
Dt Reported to Carrier/TPA is uniformly distributed Uniform
Dt Reported to Employer is uniformly distributed Uniform
Date of Injury/Illness is uniformly distributed Uniform
How Injury Occurred is uniformly distributed Uniform
Obs_ID has unique values Unique
Dependent is an unsupported type, check if it needs cleaning or further analysis Unsupported
Time of Injury/Illness has 368 (17.7%) zeros Zeros

Variables

Obs_ID
Categorical

UNIQUE

Distinct count2080
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Obs_11933
 
1
Obs_14895
 
1
Obs_1019
 
1
Obs_17662
 
1
Obs_19086
 
1
Other values (2075)
2075
ValueCountFrequency (%) 
Obs_119331< 0.1%
 
Obs_148951< 0.1%
 
Obs_10191< 0.1%
 
Obs_176621< 0.1%
 
Obs_190861< 0.1%
 
Obs_91821< 0.1%
 
Obs_162261< 0.1%
 
Obs_118821< 0.1%
 
Obs_148261< 0.1%
 
Obs_103571< 0.1%
 
Other values (2070)207099.5%
 

Length

Max length9
Median length8
Mean length8.413942308
Min length6

Dependent
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing2080
Missing (%)100.0%
Memory size16.4 KiB

Average Weekly Wage
Categorical

HIGH CARDINALITY
MISSING

Distinct count464
Unique (%)59.8%
Missing1304
Missing (%)62.7%
Memory size16.2 KiB
500
 
47
1,000.00
 
29
320
 
25
600
 
21
150
 
20
Other values (459)
634
ValueCountFrequency (%) 
500472.3%
 
1,000.00291.4%
 
320251.2%
 
600211.0%
 
150201.0%
 
1,500.00160.8%
 
400160.8%
 
100160.8%
 
800100.5%
 
30090.4%
 
Other values (454)56727.3%
 
(Missing)130462.7%
 

Length

Max length8
Median length3
Mean length3.900480769
Min length1

Body Part
Categorical

Distinct count44
Unique (%)2.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Finger(s)
 
173
Knee
 
168
Low Back Area
 
162
Other Facial Soft Tissue
 
158
Ankle
 
142
Other values (39)
1277
ValueCountFrequency (%) 
Finger(s)1738.3%
 
Knee1688.1%
 
Low Back Area1627.8%
 
Other Facial Soft Tissue1587.6%
 
Ankle1426.8%
 
Eye(s)1366.5%
 
Hand1185.7%
 
Lower Leg874.2%
 
Shoulder(s)844.0%
 
Wrist793.8%
 
Other values (34)77337.2%
 

Length

Max length54
Median length6
Mean length10.40673077
Min length3

Body Part Code
Real number (ℝ≥0)

Distinct count44
Unique (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.11730769230769
Minimum10
Maximum90
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum10
5-th percentile14
Q133
median38
Q354
95-th percentile65
Maximum90
Range80
Interquartile range (IQR)21

Descriptive statistics

Standard deviation17.2116298
Coefficient of variation (CV)0.4185981712
Kurtosis0.5356381883
Mean41.11730769
Median Absolute Deviation (MAD)15
Skewness0.4619453535
Sum85524
Variance296.2402005
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
361738.3%
 
531688.1%
 
421627.8%
 
181587.6%
 
551426.8%
 
141366.5%
 
351185.7%
 
54874.2%
 
38844.0%
 
34793.8%
 
Other values (34)77337.2%
 
ValueCountFrequency (%) 
1030.1%
 
1120.1%
 
1250.2%
 
13170.8%
 
141366.5%
 
ValueCountFrequency (%) 
90763.7%
 
6670.3%
 
65462.2%
 
63180.9%
 
6230.1%
 

Cause
Categorical

HIGH CORRELATION

Distinct count10
Unique (%)0.5%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Strain or Injury By
553
Fall, Slip or Trip Injury
368
Struck or Injured By
343
Cut, Puncture, Scrape Injured By
255
Miscellaneous Causes
251
Other values (5)
310
ValueCountFrequency (%) 
Strain or Injury By55326.6%
 
Fall, Slip or Trip Injury36817.7%
 
Struck or Injured By34316.5%
 
Cut, Puncture, Scrape Injured By25512.3%
 
Miscellaneous Causes25112.1%
 
Striking Against or Stepping on1436.9%
 
Caught In, Under or Between854.1%
 
Motor Vehicle532.5%
 
Burn or Scald - Heat or Cold Exposure281.3%
 
Rubbed or Abraded By1< 0.1%
 

Length

Max length37
Median length20
Mean length23.18269231
Min length13

Cause Code
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count10
Unique (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1490.4807692307693
Minimum1000
Maximum1900
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1000
5-th percentile1100
Q11300
median1500
Q31700
95-th percentile1900
Maximum1900
Range900
Interquartile range (IQR)400

Descriptive statistics

Standard deviation234.1785549
Coefficient of variation (CV)0.1571161197
Kurtosis-0.814782701
Mean1490.480769
Median Absolute Deviation (MAD)200
Skewness0.1279815304
Sum3100200
Variance54839.59559
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
150055326.6%
 
130036817.7%
 
170034316.5%
 
120025512.3%
 
190025112.1%
 
16001436.9%
 
1100854.1%
 
1400532.5%
 
1000281.3%
 
18001< 0.1%
 
ValueCountFrequency (%) 
1000281.3%
 
1100854.1%
 
120025512.3%
 
130036817.7%
 
1400532.5%
 
ValueCountFrequency (%) 
190025112.1%
 
18001< 0.1%
 
170034316.5%
 
16001436.9%
 
150055326.6%
 

Claimant Age
Real number (ℝ≥0)

MISSING

Distinct count62
Unique (%)3.5%
Missing308
Missing (%)14.8%
Infinite0
Infinite (%)0.0%
Mean40.090857787810386
Minimum1.0
Maximum88.0
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile22.55
Q130
median40
Q349
95-th percentile60
Maximum88
Range87
Interquartile range (IQR)19

Descriptive statistics

Standard deviation12.0022201
Coefficient of variation (CV)0.2993754877
Kurtosis-0.4956951031
Mean40.09085779
Median Absolute Deviation (MAD)9
Skewness0.2236443653
Sum71041
Variance144.0532873
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
39602.9%
 
41572.7%
 
30552.6%
 
46532.5%
 
38532.5%
 
42532.5%
 
27522.5%
 
40522.5%
 
25522.5%
 
26502.4%
 
Other values (52)123559.4%
 
(Missing)30814.8%
 
ValueCountFrequency (%) 
120.1%
 
1020.1%
 
161< 0.1%
 
1740.2%
 
1890.4%
 
ValueCountFrequency (%) 
881< 0.1%
 
771< 0.1%
 
7420.1%
 
7220.1%
 
7120.1%
 

Claimant Atty Firm Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count195
Unique (%)50.6%
Missing1695
Missing (%)81.5%
Memory size16.2 KiB
TLEVY, STERN & FORD
 
10
TJ. LEEDS BARROL, IV ATTORNEY AT LAW
 
8
TSHERMAN, FEDERMAN SAMBUR & LEVINE
 
7
TGORDON, EDELSTEIN, KREPACK, ET AL
 
6
TSCHUMMER, ROLBIN, & HURST
 
6
Other values (190)
348
ValueCountFrequency (%) 
TLEVY, STERN & FORD100.5%
 
TJ. LEEDS BARROL, IV ATTORNEY AT LAW80.4%
 
TSHERMAN, FEDERMAN SAMBUR & LEVINE70.3%
 
TGORDON, EDELSTEIN, KREPACK, ET AL60.3%
 
TSCHUMMER, ROLBIN, & HURST60.3%
 
TLAW OFFICE OF CHRISTINE T. NELSON60.3%
 
TLEVY, FORD & WALLACH60.3%
 
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO50.2%
 
TLEVY, STERN, & FORD50.2%
 
TKUSION & CAMPANA50.2%
 
Other values (185)32115.4%
 
(Missing)169581.5%
 

Length

Max length57
Median length3
Mean length7.348557692
Min length3

Claimant Gender
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Male
1661
Female
411
Uknown
 
8
ValueCountFrequency (%) 
Male166179.9%
 
Female41119.8%
 
Uknown80.4%
 

Length

Max length6
Median length4
Mean length4.402884615
Min length4

Claimant Gender Code
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
M
1661
F
411
U
 
8
ValueCountFrequency (%) 
M166179.9%
 
F41119.8%
 
U80.4%
 

Length

Max length1
Median length1
Mean length1
Min length1

Claimant Hire Date
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct count1434
Unique (%)72.8%
Missing109
Missing (%)5.2%
Memory size16.2 KiB
1/1/2005
 
14
1/1/2001
 
8
1/3/2012
 
8
2/27/2003
 
7
7/1/2012
 
6
Other values (1429)
1928
ValueCountFrequency (%) 
1/1/2005140.7%
 
1/1/200180.4%
 
1/3/201280.4%
 
2/27/200370.3%
 
7/1/201260.3%
 
3/24/200350.2%
 
9/8/200850.2%
 
1/7/201350.2%
 
4/23/201250.2%
 
1/1/200850.2%
 
Other values (1424)190391.5%
 
(Missing)1095.2%
 

Length

Max length10
Median length9
Mean length8.502884615
Min length3

Claimant Marital Status
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)0.9%
Missing1742
Missing (%)83.8%
Memory size16.2 KiB
Unmarried, Single, Widowed, Divorced
187
Married
149
Separated
 
2
ValueCountFrequency (%) 
Unmarried, Single, Widowed, Divorced1879.0%
 
Married1497.2%
 
Separated20.1%
 
(Missing)174283.8%
 

Length

Max length36
Median length3
Mean length6.259134615
Min length3

Claimant Marital Status Code
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)0.9%
Missing1742
Missing (%)83.8%
Memory size16.2 KiB
U
187
M
149
S
 
2
ValueCountFrequency (%) 
U1879.0%
 
M1497.2%
 
S20.1%
 
(Missing)174283.8%
 

Length

Max length3
Median length3
Mean length2.675
Min length1

Claimant State
Categorical

HIGH CORRELATION

Distinct count44
Unique (%)2.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
California
1186
New York
 
130
New Mexico
 
85
Georgia
 
80
North Carolina
 
79
Other values (39)
520
ValueCountFrequency (%) 
California118657.0%
 
New York1306.2%
 
New Mexico854.1%
 
Georgia803.8%
 
North Carolina793.8%
 
Texas713.4%
 
Louisiana623.0%
 
New Jersey532.5%
 
Illinois321.5%
 
Pennsylvania251.2%
 
Other values (34)27713.3%
 

Length

Max length15
Median length10
Mean length9.4625
Min length4

Claimant State Code
Categorical

HIGH CORRELATION

Distinct count44
Unique (%)2.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
CA
1186
NY
 
130
NM
 
85
GA
 
80
NC
 
79
Other values (39)
520
ValueCountFrequency (%) 
CA118657.0%
 
NY1306.2%
 
NM854.1%
 
GA803.8%
 
NC793.8%
 
TX713.4%
 
LA623.0%
 
NJ532.5%
 
IL321.5%
 
PA251.2%
 
Other values (34)27713.3%
 

Length

Max length2
Median length2
Mean length2
Min length2

Department Code
Real number (ℝ≥0)

MISSING

Distinct count21
Unique (%)2.1%
Missing1095
Missing (%)52.6%
Infinite0
Infinite (%)0.0%
Mean12.22741116751269
Minimum1.0
Maximum23.0
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile2
Q16
median14
Q318
95-th percentile21
Maximum23
Range22
Interquartile range (IQR)12

Descriptive statistics

Standard deviation6.880886977
Coefficient of variation (CV)0.5627427493
Kurtosis-1.438882831
Mean12.22741117
Median Absolute Deviation (MAD)6
Skewness-0.1487988687
Sum12044
Variance47.34660559
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
211567.5%
 
81296.2%
 
171286.2%
 
3904.3%
 
6743.6%
 
18643.1%
 
2623.0%
 
14623.0%
 
11592.8%
 
1301.4%
 
Other values (11)1316.3%
 
(Missing)109552.6%
 
ValueCountFrequency (%) 
1301.4%
 
2623.0%
 
3904.3%
 
4110.5%
 
5120.6%
 
ValueCountFrequency (%) 
2350.2%
 
22160.8%
 
211567.5%
 
20201.0%
 
19211.0%
 

Detail Cause
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count56
Unique (%)2.7%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Strain/Injury by Misc
 
204
Strain/Injury by Lifting
 
151
Struck by Falling/Flying Object
 
130
Fall/Slip, Same Level
 
127
Misc, Foreign Body in Eye
 
114
Other values (51)
1354
ValueCountFrequency (%) 
Strain/Injury by Misc2049.8%
 
Strain/Injury by Lifting1517.3%
 
Struck by Falling/Flying Object1306.2%
 
Fall/Slip, Same Level1276.1%
 
Misc, Foreign Body in Eye1145.5%
 
Strike/Step On, Fixed Object1105.3%
 
Cut/Puncture/Scrape, Object Lift/Handled1085.2%
 
Misc, Other1045.0%
 
Fall/Slip, Misc874.2%
 
Cut/Puncture/Scrape, Hand Tool673.2%
 
Other values (46)87842.2%
 

Length

Max length40
Median length25
Mean length25.66538462
Min length9

Detail Cause Code
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count56
Unique (%)2.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54.09278846153846
Minimum1
Maximum99
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile13
Q129
median57
Q375
95-th percentile97.1
Maximum99
Range98
Interquartile range (IQR)46

Descriptive statistics

Standard deviation27.02425373
Coefficient of variation (CV)0.499590694
Kurtosis-1.20231525
Mean54.09278846
Median Absolute Deviation (MAD)26
Skewness-0.09761052961
Sum112513
Variance730.3102895
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
602049.8%
 
561517.3%
 
751306.2%
 
291276.1%
 
871145.5%
 
681105.3%
 
171085.2%
 
991045.0%
 
31874.2%
 
16673.2%
 
Other values (46)87842.2%
 
ValueCountFrequency (%) 
11< 0.1%
 
2120.6%
 
31< 0.1%
 
430.1%
 
560.3%
 
ValueCountFrequency (%) 
991045.0%
 
97522.5%
 
941< 0.1%
 
90160.8%
 
871145.5%
 

Domestic vs. Foreign?
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Domestic
2061
Foreign
 
19
ValueCountFrequency (%) 
Domestic206199.1%
 
Foreign190.9%
 

Length

Max length8
Median length8
Mean length7.990865385
Min length7

Domestic vs. Foreign? Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
D
2061
F
 
19
ValueCountFrequency (%) 
D206199.1%
 
F190.9%
 

Length

Max length1
Median length1
Mean length1
Min length1

Dt Reported to Carrier/TPA
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count1547
Unique (%)74.4%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
3/15/2011
 
5
10/2/2007
 
5
11/3/2008
 
5
3/24/2010
 
4
5/26/2010
 
4
Other values (1542)
2057
ValueCountFrequency (%) 
3/15/201150.2%
 
10/2/200750.2%
 
11/3/200850.2%
 
3/24/201040.2%
 
5/26/201040.2%
 
10/22/200340.2%
 
1/27/201240.2%
 
10/18/201340.2%
 
3/7/200640.2%
 
4/4/201240.2%
 
Other values (1537)203797.9%
 

Length

Max length10
Median length9
Mean length8.948076923
Min length8

Dt Reported to Employer
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count1609
Unique (%)77.8%
Missing13
Missing (%)0.6%
Memory size16.2 KiB
10/17/2013
 
5
10/24/2007
 
5
4/20/2001
 
4
8/3/2011
 
4
7/6/2010
 
4
Other values (1604)
2045
ValueCountFrequency (%) 
10/17/201350.2%
 
10/24/200750.2%
 
4/20/200140.2%
 
8/3/201140.2%
 
7/6/201040.2%
 
6/22/201240.2%
 
6/2/200340.2%
 
3/31/201440.2%
 
3/14/201140.2%
 
2/23/201140.2%
 
Other values (1599)202597.4%
 
(Missing)130.6%
 

Length

Max length10
Median length9
Mean length8.911538462
Min length3

Employment Status
Categorical

HIGH CORRELATION

Distinct count8
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Unknown/Other
1728
Full-Time
 
307
Seasonal
 
20
Part-Time
 
12
Piece Worker
 
7
Other values (3)
 
6
ValueCountFrequency (%) 
Unknown/Other172883.1%
 
Full-Time30714.8%
 
Seasonal201.0%
 
Part-Time120.6%
 
Piece Worker70.3%
 
On Strike30.1%
 
Disabled20.1%
 
Retired1< 0.1%
 

Length

Max length13
Median length13
Mean length12.32163462
Min length7

Employment Status Code
Categorical

HIGH CORRELATION

Distinct count8
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
7
1728
1
 
307
8
 
20
2
 
12
C
 
7
Other values (3)
 
6
ValueCountFrequency (%) 
7172883.1%
 
130714.8%
 
8201.0%
 
2120.6%
 
C70.3%
 
430.1%
 
520.1%
 
61< 0.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

Date of Injury/Illness
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count1640
Unique (%)78.8%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
10/17/2013
 
5
8/3/2011
 
5
2/23/2011
 
4
6/22/2012
 
4
1/8/2003
 
4
Other values (1635)
2058
ValueCountFrequency (%) 
10/17/201350.2%
 
8/3/201150.2%
 
2/23/201140.2%
 
6/22/201240.2%
 
1/8/200340.2%
 
2/17/200640.2%
 
12/13/201040.2%
 
11/7/200540.2%
 
6/24/201140.2%
 
3/20/201340.2%
 
Other values (1630)203898.0%
 

Length

Max length10
Median length9
Mean length8.940384615
Min length8
Distinct count28
Unique (%)1.3%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
LOS ANGELE
975
SACRAMENTO
263
DALLAS WC
 
177
NEW JERSEY
 
108
CHARLOTTE
 
78
Other values (23)
479
ValueCountFrequency (%) 
LOS ANGELE97546.9%
 
SACRAMENTO26312.6%
 
DALLAS WC1778.5%
 
NEW JERSEY1085.2%
 
CHARLOTTE783.8%
 
LONG ISLAN592.8%
 
IN-STATE A572.7%
 
WC SOUTHEA562.7%
 
ATLANTA512.5%
 
ILLINOIS422.0%
 
Other values (18)21410.3%
 

Length

Max length10
Median length10
Mean length9.675961538
Min length6

How Injury Occurred
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count2077
Unique (%)99.9%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
UNKNOWN
 
2
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN
 
2
EMPLOYEE WAS WORKING ON SET WHEN HE SUSTAINED AN INSECT BITE
 
2
CAUGHT L INDEX FINGER IN DESK DRAWER AS CLOSING DRAWER
 
1
EMPLOYEE WAS LOWERING (UNLOADING) A PALLET ON TAILGATE WHEN
 
1
Other values (2072)
2072
ValueCountFrequency (%) 
UNKNOWN20.1%
 
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN20.1%
 
EMPLOYEE WAS WORKING ON SET WHEN HE SUSTAINED AN INSECT BITE20.1%
 
CAUGHT L INDEX FINGER IN DESK DRAWER AS CLOSING DRAWER1< 0.1%
 
EMPLOYEE WAS LOWERING (UNLOADING) A PALLET ON TAILGATE WHEN1< 0.1%
 
WHILE STEPPING OFF LIFT GATE - EE LOST HIS BALANCE AND FELL1< 0.1%
 
WHILE EMPLOYEE MOVING/UNLOADING SCAFFOLD OFF TRUCK HE FELL B1< 0.1%
 
EMPLOYEE WAS WORKING ON SET WHEN HE NOTICED A SMALL LUMP UND1< 0.1%
 
EE JUMPING OUT OF BOAT, HIT BOTTOM OF BOAT WITH R FOOT1< 0.1%
 
WALKING THROUGH DARKENED STAGE, HIT R ANKLE ON STEEL CART1< 0.1%
 
Other values (2067)206799.4%
 

Length

Max length60
Median length60
Mean length57.67163462
Min length7

Injury/Illness City
Categorical

HIGH CARDINALITY

Distinct count392
Unique (%)18.8%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
LOS ANGELES
308
BURBANK
 
215
UNKNOWN
 
207
NEW ORLEANS
 
97
NEW YORK
 
51
Other values (387)
1202
ValueCountFrequency (%) 
LOS ANGELES30814.8%
 
BURBANK21510.3%
 
UNKNOWN20710.0%
 
NEW ORLEANS974.7%
 
NEW YORK512.5%
 
BROOKLYN482.3%
 
WILMINGTON422.0%
 
CULVER CITY381.8%
 
ATLANTA281.3%
 
AUSTIN271.3%
 
Other values (382)101949.0%
 

Length

Max length19
Median length8
Mean length9.078846154
Min length2

Injury/Illness Postal
Categorical

HIGH CARDINALITY
MISSING

Distinct count550
Unique (%)35.1%
Missing513
Missing (%)24.7%
Memory size16.2 KiB
91502
 
194
95816
 
55
90038
 
38
91505
 
29
90028
 
26
Other values (545)
1225
ValueCountFrequency (%) 
915021949.3%
 
95816552.6%
 
90038381.8%
 
91505291.4%
 
90028261.2%
 
91608251.2%
 
91504241.2%
 
90001241.2%
 
90232211.0%
 
90009201.0%
 
Other values (540)111153.4%
 
(Missing)51324.7%
 

Length

Max length9
Median length5
Mean length4.495192308
Min length3

Injury/Illness State
Categorical

HIGH CORRELATION

Distinct count37
Unique (%)1.8%
Missing1
Missing (%)< 0.1%
Memory size16.2 KiB
California
1092
Louisiana
 
174
New York
 
171
Georgia
 
93
North Carolina
 
75
Other values (32)
474
ValueCountFrequency (%) 
California109252.5%
 
Louisiana1748.4%
 
New York1718.2%
 
Georgia934.5%
 
North Carolina753.6%
 
Texas522.5%
 
Hawaii482.3%
 
New Mexico432.1%
 
Michigan432.1%
 
Illinois351.7%
 
Other values (27)25312.2%
 

Length

Max length20
Median length10
Mean length9.455769231
Min length3

Injury/Illness State Code
Categorical

HIGH CORRELATION

Distinct count37
Unique (%)1.8%
Missing1
Missing (%)< 0.1%
Memory size16.2 KiB
CA
1092
LA
 
174
NY
 
171
GA
 
93
NC
 
75
Other values (32)
474
ValueCountFrequency (%) 
CA109252.5%
 
LA1748.4%
 
NY1718.2%
 
GA934.5%
 
NC753.6%
 
TX522.5%
 
HI482.3%
 
MI432.1%
 
NM432.1%
 
IL351.7%
 
Other values (27)25312.2%
 

Length

Max length3
Median length2
Mean length2.000480769
Min length2

Jurisdiction
Categorical

HIGH CORRELATION

Distinct count34
Unique (%)1.6%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
California
1243
New York
 
194
Louisiana
 
130
Georgia
 
81
North Carolina
 
77
Other values (29)
355
ValueCountFrequency (%) 
California124359.8%
 
New York1949.3%
 
Louisiana1306.2%
 
Georgia813.9%
 
North Carolina773.7%
 
Texas422.0%
 
Illinois371.8%
 
New Mexico341.6%
 
Hawaii321.5%
 
Pennsylvania311.5%
 
Other values (24)1798.6%
 

Length

Max length20
Median length10
Mean length9.515384615
Min length4

Jurisdiction Code
Categorical

HIGH CORRELATION

Distinct count34
Unique (%)1.6%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
CA
1243
NY
 
194
LA
 
130
GA
 
81
NC
 
77
Other values (29)
355
ValueCountFrequency (%) 
CA124359.8%
 
NY1949.3%
 
LA1306.2%
 
GA813.9%
 
NC773.7%
 
TX422.0%
 
IL371.8%
 
NM341.6%
 
HI321.5%
 
PA311.5%
 
Other values (24)1798.6%
 

Length

Max length2
Median length2
Mean length2
Min length2

Lost Time or Medical Only?
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing1
Missing (%)< 0.1%
Memory size16.2 KiB
Medical Only
1581
Lost Time
498
ValueCountFrequency (%) 
Medical Only158176.0%
 
Lost Time49823.9%
 
(Missing)1< 0.1%
 

Length

Max length12
Median length12
Mean length11.27740385
Min length3

Lost Time or Medical Only? Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing1
Missing (%)< 0.1%
Memory size16.2 KiB
MO
1581
LT
498
ValueCountFrequency (%) 
MO158176.0%
 
LT49823.9%
 
(Missing)1< 0.1%
 

Length

Max length3
Median length2
Mean length2.000480769
Min length2

Nature of Injury/Illness
Categorical

HIGH CORRELATION

Distinct count36
Unique (%)1.7%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Strain
477
Laceration
341
Specific Injury - All Other
309
Contusion
234
Sprain
144
Other values (31)
575
ValueCountFrequency (%) 
Strain47722.9%
 
Laceration34116.4%
 
Specific Injury - All Other30914.9%
 
Contusion23411.2%
 
Sprain1446.9%
 
Foreign Body1024.9%
 
Puncture944.5%
 
Fracture823.9%
 
Inflammation773.7%
 
Infection311.5%
 
Other values (26)1899.1%
 

Length

Max length59
Median length9
Mean length11.71009615
Min length4

Nature of Injury/Illness Code
Real number (ℝ≥0)

Distinct count36
Unique (%)1.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.31153846153846
Minimum1
Maximum91
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile10
Q132
median43
Q352
95-th percentile59
Maximum91
Range90
Interquartile range (IQR)20

Descriptive statistics

Standard deviation17.33155895
Coefficient of variation (CV)0.4195331279
Kurtosis-0.05355411534
Mean41.31153846
Median Absolute Deviation (MAD)9
Skewness-0.4910521822
Sum85928
Variance300.3829356
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5247722.9%
 
4034116.4%
 
5930914.9%
 
1023411.2%
 
491446.9%
 
251024.9%
 
43944.5%
 
28823.9%
 
37773.7%
 
36311.5%
 
Other values (26)1899.1%
 
ValueCountFrequency (%) 
1120.6%
 
21< 0.1%
 
4271.3%
 
7110.5%
 
1023411.2%
 
ValueCountFrequency (%) 
9150.2%
 
90150.7%
 
8080.4%
 
7830.1%
 
771< 0.1%
 

Number of Dependents
Real number (ℝ≥0)

MISSING

Distinct count5
Unique (%)7.8%
Missing2016
Missing (%)96.9%
Infinite0
Infinite (%)0.0%
Mean1.953125
Minimum1.0
Maximum5.0
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q33
95-th percentile4
Maximum5
Range4
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.075405977
Coefficient of variation (CV)0.5506078603
Kurtosis0.4923951058
Mean1.953125
Median Absolute Deviation (MAD)1
Skewness1.044102286
Sum125
Variance1.156498016
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1281.3%
 
2190.9%
 
3110.5%
 
440.2%
 
520.1%
 
(Missing)201696.9%
 
ValueCountFrequency (%) 
1281.3%
 
2190.9%
 
3110.5%
 
440.2%
 
520.1%
 
ValueCountFrequency (%) 
520.1%
 
440.2%
 
3110.5%
 
2190.9%
 
1281.3%
 

OSHA Injury Type
Categorical

HIGH CORRELATION

Distinct count6
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
Injury
2049
Skin disorder
 
20
Hearing loss
 
3
Respiratory condition
 
3
All other illnesses
 
3
ValueCountFrequency (%) 
Injury204998.5%
 
Skin disorder201.0%
 
Hearing loss30.1%
 
Respiratory condition30.1%
 
All other illnesses30.1%
 
Poisoning20.1%
 

Length

Max length21
Median length6
Mean length6.119230769
Min length6

OSHA Injury Type Code
Real number (ℝ≥0)

Distinct count6
Unique (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0283653846153846
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum6
Range5
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.2870681124
Coefficient of variation (CV)0.2791499176
Kurtosis195.7724395
Mean1.028365385
Median Absolute Deviation (MAD)0
Skewness13.23643863
Sum2139
Variance0.08240810116
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1204998.5%
 
2201.0%
 
530.1%
 
330.1%
 
630.1%
 
420.1%
 
ValueCountFrequency (%) 
1204998.5%
 
2201.0%
 
330.1%
 
420.1%
 
530.1%
 
ValueCountFrequency (%) 
630.1%
 
530.1%
 
420.1%
 
330.1%
 
2201.0%
 

Severity Index Code
Categorical

MISSING

Distinct count7
Unique (%)0.3%
Missing41
Missing (%)2.0%
Memory size16.2 KiB
No Serious Injury Indicated
2026
Back Injury involving Surgery/Extended Disability
 
7
Fractured Bone(s)
 
2
Involves AIDS, Herpes, TSS, Cancer, Other Diseases
 
1
Fatality
 
1
Other values (2)
 
2
ValueCountFrequency (%) 
No Serious Injury Indicated202697.4%
 
Back Injury involving Surgery/Extended Disability70.3%
 
Fractured Bone(s)20.1%
 
Involves AIDS, Herpes, TSS, Cancer, Other Diseases1< 0.1%
 
Fatality1< 0.1%
 
Serious Burns1< 0.1%
 
Heart Attack or Cardio-Vascular Accident1< 0.1%
 
(Missing)412.0%
 

Length

Max length50
Median length27
Mean length26.59278846
Min length3

Severity Index Code Code
Real number (ℝ≥0)

MISSING

Distinct count7
Unique (%)0.3%
Missing41
Missing (%)2.0%
Infinite0
Infinite (%)0.0%
Mean9.981853849926434
Minimum1.0
Maximum14.0
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum1
5-th percentile10
Q110
median10
Q310
95-th percentile10
Maximum14
Range13
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3150841379
Coefficient of variation (CV)0.03156569337
Kurtosis406.0059397
Mean9.98185385
Median Absolute Deviation (MAD)0
Skewness-16.23497957
Sum20353
Variance0.09927801396
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10202697.4%
 
770.3%
 
920.1%
 
61< 0.1%
 
51< 0.1%
 
11< 0.1%
 
141< 0.1%
 
(Missing)412.0%
 
ValueCountFrequency (%) 
11< 0.1%
 
51< 0.1%
 
61< 0.1%
 
770.3%
 
920.1%
 
ValueCountFrequency (%) 
141< 0.1%
 
10202697.4%
 
920.1%
 
770.3%
 
61< 0.1%
 

Time of Injury/Illness
Real number (ℝ≥0)

ZEROS

Distinct count252
Unique (%)12.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean988.2278846153846
Minimum0
Maximum2358
Zeros368
Zeros (%)17.7%
Memory size16.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1600
median1030
Q31500
95-th percentile2000
Maximum2358
Range2358
Interquartile range (IQR)900

Descriptive statistics

Standard deviation649.793849
Coefficient of variation (CV)0.65753442
Kurtosis-0.9322108012
Mean988.2278846
Median Absolute Deviation (MAD)470
Skewness-0.157018299
Sum2055514
Variance422232.0462
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
036817.7%
 
1100823.9%
 
1000793.8%
 
1500743.6%
 
800612.9%
 
1400612.9%
 
1600532.5%
 
830472.3%
 
1030462.2%
 
900462.2%
 
Other values (242)116355.9%
 
ValueCountFrequency (%) 
036817.7%
 
51< 0.1%
 
1050.2%
 
141< 0.1%
 
1590.4%
 
ValueCountFrequency (%) 
23581< 0.1%
 
234530.1%
 
233030.1%
 
23151< 0.1%
 
2300160.8%
 

Type of Loss
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing4
Missing (%)0.2%
Memory size16.2 KiB
Specific Injury
2058
Cumulative Trauma
 
18
ValueCountFrequency (%) 
Specific Injury205898.9%
 
Cumulative Trauma180.9%
 
(Missing)40.2%
 

Length

Max length17
Median length15
Mean length14.99423077
Min length3

Type of Loss Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)0.1%
Missing4
Missing (%)0.2%
Memory size16.2 KiB
3
2058
1
 
18
ValueCountFrequency (%) 
3205898.9%
 
1180.9%
 
(Missing)40.2%
 

Length

Max length3
Median length3
Mean length3
Min length3

Policy Year
Real number (ℝ≥0)

Distinct count15
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2007.5461538461539
Minimum2000
Maximum2014
Zeros0
Zeros (%)0.0%
Memory size16.2 KiB

Quantile statistics

Minimum2000
5-th percentile2001
Q12004
median2008
Q32011
95-th percentile2014
Maximum2014
Range14
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.240234755
Coefficient of variation (CV)0.00211214808
Kurtosis-1.207004565
Mean2007.546154
Median Absolute Deviation (MAD)4
Skewness-0.1583360318
Sum4175696
Variance17.97959078
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20111919.2%
 
20131868.9%
 
20121637.8%
 
20101537.4%
 
20051527.3%
 
20041507.2%
 
20071326.3%
 
20081316.3%
 
20091296.2%
 
20141296.2%
 
Other values (5)56427.1%
 
ValueCountFrequency (%) 
20001024.9%
 
20011014.9%
 
20021256.0%
 
20031256.0%
 
20041507.2%
 
ValueCountFrequency (%) 
20141296.2%
 
20131868.9%
 
20121637.8%
 
20111919.2%
 
20101537.4%
 

Reforms_dummy
Categorical

MISSING

Distinct count3
Unique (%)0.2%
Missing837
Missing (%)40.2%
Memory size16.2 KiB
California Refom 1
661
California Refom 0
434
California Reform 2
148
ValueCountFrequency (%) 
California Refom 166131.8%
 
California Refom 043420.9%
 
California Reform 21487.1%
 
(Missing)83740.2%
 

Length

Max length19
Median length18
Mean length12.03509615
Min length3

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

Obs_IDDependentAverage Weekly WageBody PartBody Part CodeCauseCause CodeClaimant AgeClaimant Atty Firm NameClaimant GenderClaimant Gender CodeClaimant Hire DateClaimant Marital StatusClaimant Marital Status CodeClaimant StateClaimant State CodeDepartment CodeDetail CauseDetail Cause CodeDomestic vs. Foreign?Domestic vs. Foreign? CodeDt Reported to Carrier/TPADt Reported to EmployerEmployment StatusEmployment Status CodeDate of Injury/IllnessHandling Office NameHow Injury OccurredInjury/Illness CityInjury/Illness PostalInjury/Illness StateInjury/Illness State CodeJurisdictionJurisdiction CodeLost Time or Medical Only?Lost Time or Medical Only? CodeNature of Injury/IllnessNature of Injury/Illness CodeNumber of DependentsOSHA Injury TypeOSHA Injury Type CodeSeverity Index CodeSeverity Index Code CodeTime of Injury/IllnessType of LossType of Loss CodePolicy YearReforms_dummy
0Obs_20NaNNaNWrist34Strain or Injury By150037.0NaNMaleM1/1/2000NaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD4/4/20052/11/2005Unknown/Other74/10/2001LOS ANGELEEE CLAIMS: CT 1991 -4/10/01 TO BILATERAL HANDS - WRISTS ANDBURBANK91502CaliforniaCACaliforniaCALost TimeLTCarpal Tunnel Syndrome78NaNInjury1No Serious Injury Indicated10.00Cumulative Trauma1.02001California Refom 1
1Obs_30NaN465Multiple Lower Extremities50Strain or Injury By150045.0NaNMaleM2/10/1996NaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD10/6/20059/28/2005Full-Time14/1/2003LOS ANGELEEE CLAIMS : CT 1990 -04 -01 -03 TO LOW BACK (L) SIDE (L) LEGBURBANK91502CaliforniaCACaliforniaCALost TimeLTStrain52NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02003California Refom 1
2Obs_36NaN237Knee53Strain or Injury By150038.0NaNMaleM3/16/2002NaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD5/17/20065/17/2006Unknown/Other712/6/2002LOS ANGELEEMPLOYEE CLAIMS: CT 12/6/01 - 12/6/02 TO LEFT KNEE FROM REPEBURBANK91502CaliforniaCACaliforniaCALost TimeLTStrain52NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02002California Refom 1
3Obs_57NaN1,378.00Multiple Body Parts90Fall, Slip or Trip Injury1300NaNNaNMaleM2/27/2001NaNNaNCaliforniaCANaNFall/Slip, Different Level25DomesticD4/17/20014/16/2001Full-Time14/16/2001LOS ANGELEWALKING ON PLYWOOD RAMP, RAMP SLIPPED AND HE FELL ON R SIDE.LAS VEGAS89101NevadaNVCaliforniaCALost TimeLTMultiple Injury, Physical Only90NaNInjury1No Serious Injury Indicated10.0730Specific Injury3.02001California Refom 0
4Obs_72NaN888Multiple Body Parts90Miscellaneous Causes190026.0NaNMaleM4/3/2001NaNNaNCaliforniaCANaNMisc, Other99DomesticD5/16/20014/20/2001Full-Time14/4/2001SACRAMENTOEE ALLEGES R SCAPULA INJURIES OF UNKNOWN CAUSEUNKNOWN91502CaliforniaCACaliforniaCAMedical OnlyMOMultiple Injury, Physical Only90NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02001California Refom 0
5Obs_77NaN1,300.00Other Facial Soft Tissue18Struck or Injured By1700NaNNaNMaleM9/25/2000NaNNaNCaliforniaCANaNStruck by Object Lifted/Handled79DomesticD5/22/20015/4/2001Full-Time15/4/2001SACRAMENTOFOLDING A CLOTHING RACK, IT COLLAPSED AND STRUCK EES HEADLAKE ARROWHEAD92352CaliforniaCACaliforniaCALost TimeLTContusion10NaNInjury1No Serious Injury Indicated10.01030Specific Injury3.02001California Refom 0
6Obs_79NaNNaNHand35Caught In, Under or Between1100NaNNaNMaleMNaNNaNNaNCaliforniaCANaNCaught In/Between, Machinery10DomesticD5/22/20013/15/2001Full-Time13/15/2001SACRAMENTOELECTRIC WORK CART SLAMMED ON MY HANDVALENCIA91355CaliforniaCACaliforniaCAMedical OnlyMOCrushing13NaNInjury1No Serious Injury Indicated10.01150Specific Injury3.02001California Refom 0
7Obs_81NaN735Multiple Body Parts90Strain or Injury By1500NaNNaNMaleM6/8/2001NaNNaNCaliforniaCANaNStrain/Injury by Jumping54DomesticD6/11/20016/11/2001Full-Time16/8/2001LOS ANGELEEE JUMPED OFF LADDER, FRACTURED R FOOT AND SPRAINED R ANKLE.LOS ANGELES91502CaliforniaCACaliforniaCALost TimeLTFracture28NaNInjury1No Serious Injury Indicated10.01500Specific Injury3.02001California Refom 0
8Obs_84NaNNaNMultiple Body Parts90Miscellaneous Causes190018.0NaNMaleM10/30/2000NaNNaNCaliforniaCANaNMisc, Other99DomesticD6/19/20013/15/2001Unknown/Other73/15/2001SACRAMENTOEE CAME INTO WORK FEELING SINUS PRESSURE & NAUSEAUNKNOWN91355CaliforniaCACaliforniaCAMedical OnlyMOMultiple Injury, Physical Only90NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02001California Refom 0
9Obs_85NaN1,967.00Chest44Fall, Slip or Trip Injury1300NaNNaNMaleM5/21/2001NaNNaNCaliforniaCANaNFall/Slip, Misc31DomesticD6/27/20016/21/2001Unknown/Other76/21/2001SACRAMENTOHANDLING FOOD SUBSTANCE, SLIPPED & FELL ON GREENBED AREALOS ANGELES90001CaliforniaCACaliforniaCAMedical OnlyMOMultiple Injury, Physical Only90NaNInjury1No Serious Injury Indicated10.01630Specific Injury3.02001California Refom 0

Last rows

Obs_IDDependentAverage Weekly WageBody PartBody Part CodeCauseCause CodeClaimant AgeClaimant Atty Firm NameClaimant GenderClaimant Gender CodeClaimant Hire DateClaimant Marital StatusClaimant Marital Status CodeClaimant StateClaimant State CodeDepartment CodeDetail CauseDetail Cause CodeDomestic vs. Foreign?Domestic vs. Foreign? CodeDt Reported to Carrier/TPADt Reported to EmployerEmployment StatusEmployment Status CodeDate of Injury/IllnessHandling Office NameHow Injury OccurredInjury/Illness CityInjury/Illness PostalInjury/Illness StateInjury/Illness State CodeJurisdictionJurisdiction CodeLost Time or Medical Only?Lost Time or Medical Only? CodeNature of Injury/IllnessNature of Injury/Illness CodeNumber of DependentsOSHA Injury TypeOSHA Injury Type CodeSeverity Index CodeSeverity Index Code CodeTime of Injury/IllnessType of LossType of Loss CodePolicy YearReforms_dummy
2070Obs_19369NaNNaNKnee53Fall, Slip or Trip Injury130040.0NaNMaleM3/31/2014NaNNaNGeorgiaGA17.0Fall/Slip, Same Level29DomesticD8/25/20148/23/2014Unknown/Other78/22/2014WC SOUTHEAEE WAS WALKING AND TRIPPED ALONG AND TRIPPED OVER WOOD AND EFAYETTEVILLE30214GeorgiaGAGeorgiaGAMedical OnlyMOStrain52NaNInjury1No Serious Injury Indicated10.01500Specific Injury3.02014NaN
2071Obs_19371NaNNaNLow Back Area42Strain or Injury By150027.0NaNMaleM7/21/2014NaNNaNNorth CarolinaNC22.0Strain/Injury by Lifting56DomesticD8/28/20148/27/2014Unknown/Other78/27/2014WC SOUTHEAEMPLOYEE WAS LIFTING HEAVY OBJECTS AND SWITCHED TO A LIGHTERWILMINGTON28411North CarolinaNCNorth CarolinaNCMedical OnlyMOStrain52NaNInjury1No Serious Injury Indicated10.01300Specific Injury3.02014NaN
2072Obs_19375NaNNaNThigh52Burn or Scald - Heat or Cold Exposure100032.0NaNFemaleF8/11/2014NaNNaNGeorgiaGA21.0Burn/Exposure, Steam/Fluid5DomesticD9/3/20149/3/2014Unknown/Other79/3/2014WC SOUTHEACLEANING UP KITCHEN AFTER LUNCH, SPILLED BOILING HOT WATER OATLANTA30336GeorgiaGAGeorgiaGAMedical OnlyMOBurn4NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02014NaN
2073Obs_19381NaN41Ankle55Strain or Injury By150040.0NaNMaleM8/19/2014NaNNaNGeorgiaGA17.0Strain/Injury by Misc60DomesticD9/5/20149/4/2014Unknown/Other79/4/2014WC SOUTHEAEMPLOYEE WAS ROOFING SHINGLES, WHEN HE TWISTED HIS RIGHT ANKSENOIANaNGeorgiaGAGeorgiaGAMedical OnlyMOSprain49NaNInjury1No Serious Injury Indicated10.01145Specific Injury3.02014NaN
2074Obs_19382NaNNaNLow Back Area42Fall, Slip or Trip Injury130050.0NaNMaleM7/20/2014NaNNaNGeorgiaGA18.0Fall/Slip, Same Level29DomesticD9/8/20149/5/2014Unknown/Other79/5/2014WC SOUTHEAEMPLOYEE HAS A POWERED MONITOR ATTACHED TO A CABLE. WHEN THEATLANTA30315GeorgiaGAGeorgiaGAMedical OnlyMOStrain52NaNInjury1No Serious Injury Indicated10.00Specific Injury3.02014NaN
2075Obs_19389NaNNaNOther Facial Soft Tissue18Fall, Slip or Trip Injury130048.0NaNFemaleF9/2/2014NaNNaNGeorgiaGA17.0Fall/Slip, Misc31DomesticD9/10/20149/10/2014Unknown/Other79/10/2014WC SOUTHEAMEDIC WAS CALLED TO THE MILL FOR PAINTER WHO HAD FALLEN. PATFAYETTEVILLE30214GeorgiaGAGeorgiaGAMedical OnlyMOContusion10NaNInjury1No Serious Injury Indicated10.0945Specific Injury3.02014NaN
2076Obs_19392NaNNaNFoot56Struck or Injured By170025.0NaNFemaleF9/2/2014NaNNaNGeorgiaGA14.0Struck by Object Lifted/Handled79DomesticD9/11/20149/11/2014Unknown/Other79/10/2014WC SOUTHEAWHILE PUSHING CARTS ONE ROLLED OVER HER FOOT. ANDREA FLADER,WILLIAMSON30292GeorgiaGAGeorgiaGAMedical OnlyMOSprain49NaNInjury1No Serious Injury Indicated10.02130Specific Injury3.02014NaN
2077Obs_19411NaNNaNKnee53Strain or Injury By150041.0NaNMaleM6/4/2014NaNNaNGeorgiaGA17.0Strain/Injury by Misc60DomesticD9/24/20149/24/2014Unknown/Other79/16/2014WC SOUTHEAEMPLOYEE WAS WALKING ON LOOSE GRAVEL WHEN HE TWISTED HIS RIGATLANTA30316GeorgiaGAGeorgiaGAMedical OnlyMOStrain52NaNInjury1No Serious Injury Indicated10.01000Specific Injury3.02014NaN
2078Obs_19424NaNNaNToe(s)57Struck or Injured By170035.0NaNMaleM7/14/2014NaNNaNMarylandMD17.0Struck by Object Lifted/Handled79DomesticD9/30/20149/30/2014Unknown/Other79/30/2014WC SOUTHEAMOVING WALL AND THE WALL CAME DOWN CRUSHING EE TOE. PRODUCTICOLUMBIA21046MarylandMDMarylandMDMedical OnlyMOCrushing13NaNInjury1No Serious Injury Indicated10.01420Specific Injury3.02014NaN
2079Obs_19495NaNNaNKnee53Fall, Slip or Trip Injury130047.0NaNMaleM1/1/2014NaNNaNVirginiaVA18.0Fall/Slip, Same Level29DomesticD11/10/201411/7/2014Unknown/Other711/7/2014WC SOUTHEAEE WAS PUSHING SOUND CART IN WOODS WHEN HE TRIPPED ON A TREERICHMOND23226VirginiaVAVirginiaVANaNNaNSprain49NaNInjury1No Serious Injury Indicated10.01700Specific Injury3.02014NaN